/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 1816

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 55 50 44 41 54 45 20 48 | 45 41 44 45 52 00 63 72 |UPDATE H|EADER.cr|
|00000010| 65 61 74 65 20 74 72 69 | 67 67 65 72 20 74 25 31 |eate tri|gger t%1|
|00000020| 41 63 74 69 6f 6e 5f 25 | 32 37 54 61 62 6c 65 4e |Action_%|27TableN|
|00000030| 61 6d 65 20 61 66 74 65 | 72 20 25 41 63 74 69 6f |ame afte|r %Actio|
|00000040| 6e 20 6f 6e 20 25 54 61 | 62 6c 65 4e 61 6d 65 0d |n on %Ta|bleName.|
|00000050| 0a 72 65 66 65 72 65 6e | 63 69 6e 67 20 6f 6c 64 |.referen|cing old|
|00000060| 20 61 73 20 25 4f 6c 64 | 20 6e 65 77 20 61 73 20 | as %Old| new as |
|00000070| 25 4e 65 77 0d 0a 66 6f | 72 20 65 61 63 68 20 72 |%New..fo|r each r|
|00000080| 6f 77 0d 0a 2d 2d 20 45 | 52 77 69 6e 20 42 75 69 |ow..-- E|Rwin Bui|
|00000090| 6c 74 69 6e 20 25 44 61 | 74 65 74 69 6d 65 20 0d |ltin %Da|tetime .|
|000000a0| 0a 2d 2d 20 25 41 63 74 | 69 6f 6e 20 74 72 69 67 |.-- %Act|ion trig|
|000000b0| 67 65 72 20 6f 6e 20 25 | 54 61 62 6c 65 4e 61 6d |ger on %|TableNam|
|000000c0| 65 20 0d 0a 62 65 67 69 | 6e 0d 0a 20 20 64 65 63 |e ..begi|n..  dec|
|000000d0| 6c 61 72 65 20 6e 75 6d | 72 6f 77 73 20 49 4e 54 |lare num|rows INT|
|000000e0| 45 47 45 52 3b 0d 0a 20 | 20 64 65 63 6c 61 72 65 |EGER;.. | declare|
|000000f0| 20 70 61 72 65 6e 74 5f | 75 70 64 72 73 74 72 63 | parent_|updrstrc|
|00000100| 74 5f 65 72 72 20 45 58 | 43 45 50 54 49 4f 4e 20 |t_err EX|CEPTION |
|00000110| 46 4f 52 20 53 51 4c 53 | 54 41 54 45 20 56 41 4c |FOR SQLS|TATE VAL|
|00000120| 55 45 20 27 50 61 72 65 | 6e 74 20 55 70 64 61 74 |UE 'Pare|nt Updat|
|00000130| 65 20 52 65 73 74 72 69 | 63 74 27 3b 0d 0a 20 20 |e Restri|ct';..  |
|00000140| 64 65 63 6c 61 72 65 20 | 63 68 69 6c 64 5f 75 70 |declare |child_up|
|00000150| 64 72 73 74 72 63 74 5f | 65 72 72 20 45 58 43 45 |drstrct_|err EXCE|
|00000160| 50 54 49 4f 4e 20 46 4f | 52 20 53 51 4c 53 54 41 |PTION FO|R SQLSTA|
|00000170| 54 45 20 56 41 4c 55 45 | 20 27 43 68 69 6c 64 20 |TE VALUE| 'Child |
|00000180| 55 70 64 61 74 65 20 52 | 65 73 74 72 69 63 74 27 |Update R|estrict'|
|00000190| 3b 0d 0a 00 28 27       |                         |;...('  |        |
+--------+-------------------------+-------------------------+--------+--------+